package com.fitmanagement.mapper;

import com.fitmanagement.entity.Usercard;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author 虚空
 * @since 2024-11-11
 */
public interface UsercardMapper extends BaseMapper<Usercard> {
    @Select("SELECT users.Username FROM users, usercard WHERE users.UserID = usercard.UserID AND usercard.UserID = #{UserId}")
     String selectColumn(@Param("UserId") int UserId);



}
